You have the option to group data in a report to show hierarchical relationships. When you group data hierarchically, you sort information based on the relationship between two fields.
For example, if you want to show the hierarchical structure of a department, you could group data by employee ID and specify the hierarchy using the data field listing whom the employee reports to.
For example, if you want to view the hierarchical structure of a company's employee's, select the employee ID data field. If you want to view the hierarchical structure of region sales offices, select office names.
For example, if you grouped by {Employee.EmployeeID}, at each change of a group you will see the corresponding employee ID. If you want to display a different value (employee name instead of employee ID), customize the group name field by choosing an alternate data field, or creating a formula.
The group you created is added to the report.
The Hierarchical Options dialog box appears.
If you've created only one group on your report, then it will be selected automatically in the Available Groups list.
For instance, for a company hierarchical report, you might select the data field listing the supervisor to whom the employee reports.
Note: The Instance ID and Parent ID fields must be of the same data type. For example, if the Instance ID field holds string data, then the Parent ID field must also hold string data.
The report data is now grouped hierarchically. If necessary, you can now calculate summary fields across your new hierarchical grouping. When inserting a Subtotal, Grand Total, or Summary in the usual manner, select the "Sum across hierarchy" option. For more information, see Summarizing grouped data and Subtotaling.
Tip: If you want to suppress the group header, select the group header. On the Format menu, click Paragraph formatting. Click the Suppress check box.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |